{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "cb7f2094",
   "metadata": {},
   "source": [
    "* 备注\n",
    "> 1.城市： '北京、 '上海'、 '广州'、'深圳'       \n",
    "> 2.行业：广告行业              \n",
    "> 2.关键词：4A广告公司，广告策划，广告文案，营销策划类广告人才                         \n",
    "> 3.学历：本科及本科以上             "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "b599a094",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "登录cookie XSRF-TOKEN=zIARnRM0QQaLudJk_4OBXw; __gc_id=e936feed5bd343e5a73b304fa0d4ad5f; _ga=GA1.1.504776059.1697021947; __uuid=1697021948310.51; __tlog=1697021948354.48%7C00000000%7C00000000%7C00000000%7C00000000; Hm_lvt_a2647413544f5a04f00da7eee0d5e200=1697021951; acw_tc=2760828416970219810274366e53a098388abcfc886c89f5cbf2332344893f; Hm_lpvt_a2647413544f5a04f00da7eee0d5e200=1697021975; __session_seq=4; __uv_seq=4; __tlg_event_seq=24; _ga_54YTJKWN86=GS1.1.1697021946.1.1.1697023027.0.0.0\n",
      "这是第1页，接下来将先等待10秒...然后以继续抓取\n",
      "这是第2页，接下来将先等待4秒...然后以继续抓取\n",
      "这是第3页，接下来将先等待6秒...然后以继续抓取\n",
      "这是第4页，接下来将先等待3秒...然后以继续抓取\n",
      "这是第5页，接下来将先等待9秒...然后以继续抓取\n",
      "这是第6页，接下来将先等待3秒...然后以继续抓取\n",
      "这是第7页，接下来将先等待10秒...然后以继续抓取\n",
      "这是第8页，接下来将先等待10秒...然后以继续抓取\n",
      "这是第9页，接下来将先等待8秒...然后以继续抓取\n",
      "这是第10页，接下来将先等待9秒...然后以继续抓取\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>dataInfo</th>\n",
       "      <th>dataParams</th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.link</th>\n",
       "      <th>job.jobKind</th>\n",
       "      <th>job.topJob</th>\n",
       "      <th>job.advViewFlag</th>\n",
       "      <th>job.jobId</th>\n",
       "      <th>job.title</th>\n",
       "      <th>job.refreshTime</th>\n",
       "      <th>...</th>\n",
       "      <th>recruiter.recruiterId</th>\n",
       "      <th>recruiter.recruiterPhoto</th>\n",
       "      <th>comp.link</th>\n",
       "      <th>comp.compId</th>\n",
       "      <th>comp.compScale</th>\n",
       "      <th>comp.compLogo</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>comp.compStage</th>\n",
       "      <th>job.campusJobKind</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22jobId%22%3A%22...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"jobId\":\"62879931\",\"userId\":\"de...</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://www.liepin.com/job/1962879931.shtml</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>62879931</td>\n",
       "      <td>产品经理</td>\n",
       "      <td>20231113155641</td>\n",
       "      <td>...</td>\n",
       "      <td>def33da508391ad49d27ab92b25bca56</td>\n",
       "      <td>5f8f9866dfb13a7dee342f1808u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/13335729/</td>\n",
       "      <td>13335729</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>63915356535ce6488ba056c702u.png</td>\n",
       "      <td>生物技术</td>\n",
       "      <td>浙江伊瑟奇</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22jobId%22%3A%22...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"jobId\":\"63088621\",\"userId\":\"a9...</td>\n",
       "      <td>[CRA]</td>\n",
       "      <td>https://www.liepin.com/job/1963088621.shtml</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>63088621</td>\n",
       "      <td>临床监察员CRA</td>\n",
       "      <td>20231121175343</td>\n",
       "      <td>...</td>\n",
       "      <td>a9ecc902291cd144635ee9a80b163e59</td>\n",
       "      <td>5f8f9863f6d1ab58476f246a08u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/1056235/</td>\n",
       "      <td>1056235</td>\n",
       "      <td>10000人以上</td>\n",
       "      <td>5b8c9aaf8e50a3257f37fa7104a.jpg</td>\n",
       "      <td>制药</td>\n",
       "      <td>济民可信</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22jobId%22%3A%22...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"jobId\":\"61798915\",\"userId\":\"6c...</td>\n",
       "      <td>[英语, 生物]</td>\n",
       "      <td>https://www.liepin.com/job/1961798915.shtml</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>61798915</td>\n",
       "      <td>全科雅思全职兼班主任老师</td>\n",
       "      <td>20231130150950</td>\n",
       "      <td>...</td>\n",
       "      <td>6c58cf4304a4d0e16ce019a9c450308b</td>\n",
       "      <td>60764e7ee526fa171d5b793203u.png</td>\n",
       "      <td>https://www.liepin.com/company/12392003/</td>\n",
       "      <td>12392003</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>5f5f09e99d37de587973b01204u.png</td>\n",
       "      <td>互联网</td>\n",
       "      <td>罗斯德英领教育科技(北京)有限公司</td>\n",
       "      <td>融资未公开</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>%7B%22jobKind%22%3A%226%22%2C%22jobId%22%3A%22...</td>\n",
       "      <td>{\"jobKind\":\"6\",\"jobId\":\"63343083\",\"userId\":\"f8...</td>\n",
       "      <td>[3个月, 提供转正, 大专, 用户运营]</td>\n",
       "      <td>https://www.liepin.com/lptjob/63343083</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>63343083</td>\n",
       "      <td>实习生</td>\n",
       "      <td>20231201184139</td>\n",
       "      <td>...</td>\n",
       "      <td>f8122d6db311a9e0db77dbf66436772f</td>\n",
       "      <td>5f8f986bdfb13a7dee342f2108u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/13464189/</td>\n",
       "      <td>13464189</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>61b07937d0458d53c627567e02u.jpg</td>\n",
       "      <td>培训服务</td>\n",
       "      <td>北京易低优科技有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>实习</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>%7B%22jobKind%22%3A%226%22%2C%22jobId%22%3A%22...</td>\n",
       "      <td>{\"jobKind\":\"6\",\"jobId\":\"63343075\",\"userId\":\"02...</td>\n",
       "      <td>[3个月, 大专]</td>\n",
       "      <td>https://www.liepin.com/lptjob/63343075</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>63343075</td>\n",
       "      <td>设计实习生(J15137)</td>\n",
       "      <td>20231201184107</td>\n",
       "      <td>...</td>\n",
       "      <td>024a744441563d1855c69fc5496d8d13</td>\n",
       "      <td>5f8f986bdfb13a7dee342f2108u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/8603746/</td>\n",
       "      <td>8603746</td>\n",
       "      <td>5000-10000人</td>\n",
       "      <td>654dcff10013463dd227d3fc03u.png</td>\n",
       "      <td>互联网</td>\n",
       "      <td>海马体</td>\n",
       "      <td>NaN</td>\n",
       "      <td>实习</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>%7B%22jobKind%22%3A%226%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"jobKind\":\"6\",\"userId\":\"4c3769fe86c1917810603...</td>\n",
       "      <td>[3个月, 提供转正, 本科, 电商直播]</td>\n",
       "      <td>https://www.liepin.com/lptjob/63317533</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>63317533</td>\n",
       "      <td>抖音主播</td>\n",
       "      <td>20231130193404</td>\n",
       "      <td>...</td>\n",
       "      <td>4c3769fe86c1917810603e306d00c683</td>\n",
       "      <td>5f8f986bdfb13a7dee342f2108u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/13566605/</td>\n",
       "      <td>13566605</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>61b07937d0458d53c627567e02u.jpg</td>\n",
       "      <td>电力/热力/燃气/水务</td>\n",
       "      <td>苏州康昌投资有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>实习</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>%7B%22jobKind%22%3A%226%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"jobKind\":\"6\",\"userId\":\"8258f00873bad341974d4...</td>\n",
       "      <td>[6个月, 硕士, C++, Matlab, Python, 图像开发, 系统开发, C#,...</td>\n",
       "      <td>https://www.liepin.com/lptjob/63317463</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>63317463</td>\n",
       "      <td>数字疗法团队招聘视频分析软件开发实习生</td>\n",
       "      <td>20231130192630</td>\n",
       "      <td>...</td>\n",
       "      <td>8258f00873bad341974d416bdb1b171a</td>\n",
       "      <td>64bfa118788f26762d8e2bd003u.png</td>\n",
       "      <td>https://www.liepin.com/company/13614789/</td>\n",
       "      <td>13614789</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>61b07937d0458d53c627567e02u.jpg</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>北京华创典藏文化传播有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>实习</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>%7B%22jobKind%22%3A%226%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"jobKind\":\"6\",\"userId\":\"0180ae9f5d24789166ef2...</td>\n",
       "      <td>[3个月, 本科]</td>\n",
       "      <td>https://www.liepin.com/lptjob/63317387</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>63317387</td>\n",
       "      <td>材料实习生</td>\n",
       "      <td>20231130191925</td>\n",
       "      <td>...</td>\n",
       "      <td>0180ae9f5d24789166ef296e6c57d1c1</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/7915257/</td>\n",
       "      <td>7915257</td>\n",
       "      <td>10000人以上</td>\n",
       "      <td>5bfe9f2474719d2aa34bb65403a.png</td>\n",
       "      <td>专业技术服务</td>\n",
       "      <td>日立中国</td>\n",
       "      <td>NaN</td>\n",
       "      <td>实习</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>%7B%22jobKind%22%3A%226%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"jobKind\":\"6\",\"userId\":\"6f67f92c6d9b050b4ddc9...</td>\n",
       "      <td>[本科]</td>\n",
       "      <td>https://www.liepin.com/lptjob/63317185</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>63317185</td>\n",
       "      <td>项目运营</td>\n",
       "      <td>20231130190217</td>\n",
       "      <td>...</td>\n",
       "      <td>6f67f92c6d9b050b4ddc906c81ac718a</td>\n",
       "      <td>5f8f9866dfb13a7dee342f1808u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/2485876/</td>\n",
       "      <td>2485876</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>5bfea3e974719d2aa34ca07303a.png</td>\n",
       "      <td>培训服务</td>\n",
       "      <td>新东方教育科技集团有限公司</td>\n",
       "      <td>已上市</td>\n",
       "      <td>应届</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>%7B%22jobKind%22%3A%226%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"jobKind\":\"6\",\"userId\":\"5d87fcffaaa2b6273a615...</td>\n",
       "      <td>[本科]</td>\n",
       "      <td>https://www.liepin.com/lptjob/63316839</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>63316839</td>\n",
       "      <td>Offshore Operation New Grad海上平台生产操作岗位</td>\n",
       "      <td>20231130184745</td>\n",
       "      <td>...</td>\n",
       "      <td>5d87fcffaaa2b6273a61584b5f931ea8</td>\n",
       "      <td>5f8f986779c7cc70efbf36c008u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/8601187/</td>\n",
       "      <td>8601187</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>60f674059651103a464173ad08u.png</td>\n",
       "      <td>石化</td>\n",
       "      <td>哈斯基石油</td>\n",
       "      <td>NaN</td>\n",
       "      <td>应届</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>400 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             dataInfo  \\\n",
       "0   %7B%22jobKind%22%3A%222%22%2C%22jobId%22%3A%22...   \n",
       "1   %7B%22jobKind%22%3A%222%22%2C%22jobId%22%3A%22...   \n",
       "2   %7B%22jobKind%22%3A%222%22%2C%22jobId%22%3A%22...   \n",
       "3   %7B%22jobKind%22%3A%226%22%2C%22jobId%22%3A%22...   \n",
       "4   %7B%22jobKind%22%3A%226%22%2C%22jobId%22%3A%22...   \n",
       "..                                                ...   \n",
       "35  %7B%22jobKind%22%3A%226%22%2C%22pageSize%22%3A...   \n",
       "36  %7B%22jobKind%22%3A%226%22%2C%22pageSize%22%3A...   \n",
       "37  %7B%22jobKind%22%3A%226%22%2C%22pageSize%22%3A...   \n",
       "38  %7B%22jobKind%22%3A%226%22%2C%22pageSize%22%3A...   \n",
       "39  %7B%22jobKind%22%3A%226%22%2C%22pageSize%22%3A...   \n",
       "\n",
       "                                           dataParams  \\\n",
       "0   {\"jobKind\":\"2\",\"jobId\":\"62879931\",\"userId\":\"de...   \n",
       "1   {\"jobKind\":\"2\",\"jobId\":\"63088621\",\"userId\":\"a9...   \n",
       "2   {\"jobKind\":\"2\",\"jobId\":\"61798915\",\"userId\":\"6c...   \n",
       "3   {\"jobKind\":\"6\",\"jobId\":\"63343083\",\"userId\":\"f8...   \n",
       "4   {\"jobKind\":\"6\",\"jobId\":\"63343075\",\"userId\":\"02...   \n",
       "..                                                ...   \n",
       "35  {\"jobKind\":\"6\",\"userId\":\"4c3769fe86c1917810603...   \n",
       "36  {\"jobKind\":\"6\",\"userId\":\"8258f00873bad341974d4...   \n",
       "37  {\"jobKind\":\"6\",\"userId\":\"0180ae9f5d24789166ef2...   \n",
       "38  {\"jobKind\":\"6\",\"userId\":\"6f67f92c6d9b050b4ddc9...   \n",
       "39  {\"jobKind\":\"6\",\"userId\":\"5d87fcffaaa2b6273a615...   \n",
       "\n",
       "                                           job.labels  \\\n",
       "0                                                  []   \n",
       "1                                               [CRA]   \n",
       "2                                            [英语, 生物]   \n",
       "3                               [3个月, 提供转正, 大专, 用户运营]   \n",
       "4                                           [3个月, 大专]   \n",
       "..                                                ...   \n",
       "35                              [3个月, 提供转正, 本科, 电商直播]   \n",
       "36  [6个月, 硕士, C++, Matlab, Python, 图像开发, 系统开发, C#,...   \n",
       "37                                          [3个月, 本科]   \n",
       "38                                               [本科]   \n",
       "39                                               [本科]   \n",
       "\n",
       "                                       job.link job.jobKind  job.topJob  \\\n",
       "0   https://www.liepin.com/job/1962879931.shtml           2        True   \n",
       "1   https://www.liepin.com/job/1963088621.shtml           2        True   \n",
       "2   https://www.liepin.com/job/1961798915.shtml           2        True   \n",
       "3        https://www.liepin.com/lptjob/63343083           6       False   \n",
       "4        https://www.liepin.com/lptjob/63343075           6       False   \n",
       "..                                          ...         ...         ...   \n",
       "35       https://www.liepin.com/lptjob/63317533           6       False   \n",
       "36       https://www.liepin.com/lptjob/63317463           6       False   \n",
       "37       https://www.liepin.com/lptjob/63317387           6       False   \n",
       "38       https://www.liepin.com/lptjob/63317185           6       False   \n",
       "39       https://www.liepin.com/lptjob/63316839           6       False   \n",
       "\n",
       "    job.advViewFlag job.jobId                              job.title  \\\n",
       "0              True  62879931                                   产品经理   \n",
       "1              True  63088621                               临床监察员CRA   \n",
       "2              True  61798915                           全科雅思全职兼班主任老师   \n",
       "3             False  63343083                                    实习生   \n",
       "4             False  63343075                          设计实习生(J15137)   \n",
       "..              ...       ...                                    ...   \n",
       "35            False  63317533                                   抖音主播   \n",
       "36            False  63317463                    数字疗法团队招聘视频分析软件开发实习生   \n",
       "37            False  63317387                                  材料实习生   \n",
       "38            False  63317185                                   项目运营   \n",
       "39            False  63316839  Offshore Operation New Grad海上平台生产操作岗位   \n",
       "\n",
       "   job.refreshTime  ...             recruiter.recruiterId  \\\n",
       "0   20231113155641  ...  def33da508391ad49d27ab92b25bca56   \n",
       "1   20231121175343  ...  a9ecc902291cd144635ee9a80b163e59   \n",
       "2   20231130150950  ...  6c58cf4304a4d0e16ce019a9c450308b   \n",
       "3   20231201184139  ...  f8122d6db311a9e0db77dbf66436772f   \n",
       "4   20231201184107  ...  024a744441563d1855c69fc5496d8d13   \n",
       "..             ...  ...                               ...   \n",
       "35  20231130193404  ...  4c3769fe86c1917810603e306d00c683   \n",
       "36  20231130192630  ...  8258f00873bad341974d416bdb1b171a   \n",
       "37  20231130191925  ...  0180ae9f5d24789166ef296e6c57d1c1   \n",
       "38  20231130190217  ...  6f67f92c6d9b050b4ddc906c81ac718a   \n",
       "39  20231130184745  ...  5d87fcffaaa2b6273a61584b5f931ea8   \n",
       "\n",
       "           recruiter.recruiterPhoto                                 comp.link  \\\n",
       "0   5f8f9866dfb13a7dee342f1808u.jpg  https://www.liepin.com/company/13335729/   \n",
       "1   5f8f9863f6d1ab58476f246a08u.jpg   https://www.liepin.com/company/1056235/   \n",
       "2   60764e7ee526fa171d5b793203u.png  https://www.liepin.com/company/12392003/   \n",
       "3   5f8f986bdfb13a7dee342f2108u.jpg  https://www.liepin.com/company/13464189/   \n",
       "4   5f8f986bdfb13a7dee342f2108u.jpg   https://www.liepin.com/company/8603746/   \n",
       "..                              ...                                       ...   \n",
       "35  5f8f986bdfb13a7dee342f2108u.jpg  https://www.liepin.com/company/13566605/   \n",
       "36  64bfa118788f26762d8e2bd003u.png  https://www.liepin.com/company/13614789/   \n",
       "37  5f8f9865ea60860b75384fa508u.jpg   https://www.liepin.com/company/7915257/   \n",
       "38  5f8f9866dfb13a7dee342f1808u.jpg   https://www.liepin.com/company/2485876/   \n",
       "39  5f8f986779c7cc70efbf36c008u.jpg   https://www.liepin.com/company/8601187/   \n",
       "\n",
       "   comp.compId comp.compScale                    comp.compLogo  \\\n",
       "0     13335729         50-99人  63915356535ce6488ba056c702u.png   \n",
       "1      1056235       10000人以上  5b8c9aaf8e50a3257f37fa7104a.jpg   \n",
       "2     12392003          1-49人  5f5f09e99d37de587973b01204u.png   \n",
       "3     13464189       100-499人  61b07937d0458d53c627567e02u.jpg   \n",
       "4      8603746    5000-10000人  654dcff10013463dd227d3fc03u.png   \n",
       "..         ...            ...                              ...   \n",
       "35    13566605       100-499人  61b07937d0458d53c627567e02u.jpg   \n",
       "36    13614789         50-99人  61b07937d0458d53c627567e02u.jpg   \n",
       "37     7915257       10000人以上  5bfe9f2474719d2aa34bb65403a.png   \n",
       "38     2485876       100-499人  5bfea3e974719d2aa34ca07303a.png   \n",
       "39     8601187       100-499人  60f674059651103a464173ad08u.png   \n",
       "\n",
       "   comp.compIndustry      comp.compName comp.compStage  job.campusJobKind  \n",
       "0               生物技术              浙江伊瑟奇            NaN                NaN  \n",
       "1                 制药               济民可信            NaN                NaN  \n",
       "2                互联网  罗斯德英领教育科技(北京)有限公司          融资未公开                NaN  \n",
       "3               培训服务        北京易低优科技有限公司            NaN                 实习  \n",
       "4                互联网                海马体            NaN                 实习  \n",
       "..               ...                ...            ...                ...  \n",
       "35       电力/热力/燃气/水务         苏州康昌投资有限公司            NaN                 实习  \n",
       "36             计算机软件     北京华创典藏文化传播有限公司            NaN                 实习  \n",
       "37            专业技术服务               日立中国            NaN                 实习  \n",
       "38              培训服务      新东方教育科技集团有限公司            已上市                 应届  \n",
       "39                石化              哈斯基石油            NaN                 应届  \n",
       "\n",
       "[400 rows x 32 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import crawl_liepin\n",
    "\n",
    "crawl_liepin.crawl(城市=\"\",关键词=\"\",学历= \"\",行业=\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "d3045127",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "登录cookie XSRF-TOKEN=zIARnRM0QQaLudJk_4OBXw; __gc_id=e936feed5bd343e5a73b304fa0d4ad5f; _ga=GA1.1.504776059.1697021947; __uuid=1697021948310.51; __tlog=1697021948354.48%7C00000000%7C00000000%7C00000000%7C00000000; Hm_lvt_a2647413544f5a04f00da7eee0d5e200=1697021951; acw_tc=2760828416970219810274366e53a098388abcfc886c89f5cbf2332344893f; Hm_lpvt_a2647413544f5a04f00da7eee0d5e200=1697021975; __session_seq=4; __uv_seq=4; __tlg_event_seq=24; _ga_54YTJKWN86=GS1.1.1697021946.1.1.1697023027.0.0.0\n",
      "这是第1页，接下来将先等待10秒...然后以继续抓取\n",
      "这是第2页，接下来将先等待6秒...然后以继续抓取\n",
      "这是第3页，接下来将先等待7秒...然后以继续抓取\n",
      "这是第4页，接下来将先等待5秒...然后以继续抓取\n",
      "这是第5页，接下来将先等待10秒...然后以继续抓取\n",
      "这是第6页，接下来将先等待10秒...然后以继续抓取\n",
      "这是第7页，接下来将先等待8秒...然后以继续抓取\n",
      "这是第8页，接下来将先等待8秒...然后以继续抓取\n",
      "这是第9页，接下来将先等待3秒...然后以继续抓取\n",
      "这是第10页，接下来将先等待4秒...然后以继续抓取\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>dataInfo</th>\n",
       "      <th>dataParams</th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.link</th>\n",
       "      <th>job.jobId</th>\n",
       "      <th>job.dq</th>\n",
       "      <th>job.topJob</th>\n",
       "      <th>job.refreshTime</th>\n",
       "      <th>job.jobKind</th>\n",
       "      <th>job.title</th>\n",
       "      <th>...</th>\n",
       "      <th>recruiter.recruiterId</th>\n",
       "      <th>recruiter.recruiterPhoto</th>\n",
       "      <th>comp.link</th>\n",
       "      <th>comp.compId</th>\n",
       "      <th>comp.compScale</th>\n",
       "      <th>comp.compLogo</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>job.campusJobKind</th>\n",
       "      <th>comp.compStage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>%7B%22jobId%22%3A%2263221469%22%2C%22pageSize%...</td>\n",
       "      <td>{\"jobId\":\"63221469\",\"imId\":\"f3a453fd191548accb...</td>\n",
       "      <td>[公关策划, 品牌推广, 市场推广, 市场营销, 市场策划, 市场调研分析, 品牌活动, 电...</td>\n",
       "      <td>https://www.liepin.com/job/1963221469.shtml</td>\n",
       "      <td>63221469</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>True</td>\n",
       "      <td>20231127190756</td>\n",
       "      <td>2</td>\n",
       "      <td>市场经理</td>\n",
       "      <td>...</td>\n",
       "      <td>6e60308e0d7e0a5d35b7122fd419b76f</td>\n",
       "      <td>5f8f986779c7cc70efbf36c008u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/13165103/</td>\n",
       "      <td>13165103</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>6247ff3b3247ad31bb6a350808u.png</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>贝克斯数字媒体技术(深圳)有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>%7B%22jobId%22%3A%2263078431%22%2C%22pageSize%...</td>\n",
       "      <td>{\"jobId\":\"63078431\",\"imId\":\"ff0eab8eea20c36621...</td>\n",
       "      <td>[本科, 市场策划, 活动策划, 教育培训]</td>\n",
       "      <td>https://www.liepin.com/lptjob/63078431</td>\n",
       "      <td>63078431</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>False</td>\n",
       "      <td>20231127145532</td>\n",
       "      <td>6</td>\n",
       "      <td>国际合作专员</td>\n",
       "      <td>...</td>\n",
       "      <td>31ae35dd25c393cef0498bd9e03ba548</td>\n",
       "      <td>5f8f986779c7cc70efbf36c008u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/13332619/</td>\n",
       "      <td>13332619</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>65643db3aef7c833d61189e304u.png</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>正壹会展集团</td>\n",
       "      <td>应届</td>\n",
       "      <td>其他</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>%7B%22jobId%22%3A%2262439369%22%2C%22pageSize%...</td>\n",
       "      <td>{\"jobId\":\"62439369\",\"imId\":\"cad5be4e96049ddf80...</td>\n",
       "      <td>[6个月, 本科]</td>\n",
       "      <td>https://www.liepin.com/lptjob/62439369</td>\n",
       "      <td>62439369</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>False</td>\n",
       "      <td>20231027110528</td>\n",
       "      <td>6</td>\n",
       "      <td>合同管理 intern (MJ000210)</td>\n",
       "      <td>...</td>\n",
       "      <td>062818603e680b2da5f99130e9ef8d12</td>\n",
       "      <td>5f8f9866dfb13a7dee342f1808u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/9638001/</td>\n",
       "      <td>9638001</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>5ef7eac6639c8353865e8cfa03u.jpeg</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>上海邑炎信息科技有限公司</td>\n",
       "      <td>实习</td>\n",
       "      <td>融资未公开</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>%7B%22jobId%22%3A%2262386299%22%2C%22pageSize%...</td>\n",
       "      <td>{\"jobId\":\"62386299\",\"imId\":\"17cca1ce48d9b11714...</td>\n",
       "      <td>[本科, 销售方向, 销售]</td>\n",
       "      <td>https://www.liepin.com/lptjob/62386299</td>\n",
       "      <td>62386299</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>False</td>\n",
       "      <td>20231109094658</td>\n",
       "      <td>6</td>\n",
       "      <td>营销培训生</td>\n",
       "      <td>...</td>\n",
       "      <td>e7d4c09bd9ad172d971ee8f2edea25b2</td>\n",
       "      <td>63031de9636e1b234ac6a45505u.png</td>\n",
       "      <td>https://www.liepin.com/company/9272548/</td>\n",
       "      <td>9272548</td>\n",
       "      <td>5000-10000人</td>\n",
       "      <td>636c9f9f19919c4d06ca723f04u.png</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>新潮传媒集团</td>\n",
       "      <td>应届</td>\n",
       "      <td>D轮</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>%7B%22jobId%22%3A%2261949069%22%2C%22pageSize%...</td>\n",
       "      <td>{\"jobId\":\"61949069\",\"imId\":\"b099ed3311071e4673...</td>\n",
       "      <td>[3个月, 本科, 人力资源经验]</td>\n",
       "      <td>https://www.liepin.com/lptjob/61949069</td>\n",
       "      <td>61949069</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>False</td>\n",
       "      <td>20231201175815</td>\n",
       "      <td>6</td>\n",
       "      <td>行政人事实习生</td>\n",
       "      <td>...</td>\n",
       "      <td>178348d10d4504ecab26c2c2437115e0</td>\n",
       "      <td>583f8dfa70324d1f7da02d2606a.png</td>\n",
       "      <td>https://www.liepin.com/company/8904732/</td>\n",
       "      <td>8904732</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>6045d2d247efeb69daf7dd0708u.png</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>博雅公关</td>\n",
       "      <td>实习</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"recruiterName\":\"梁女士\",\"imId\":\"43372946af5e7c5...</td>\n",
       "      <td>[品牌公关, 商务公关, 媒介公关, 活动公关, 会议论坛, 发布会, to B, to G...</td>\n",
       "      <td>https://www.liepin.com/job/1959644973.shtml</td>\n",
       "      <td>59644973</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>False</td>\n",
       "      <td>20231129145821</td>\n",
       "      <td>2</td>\n",
       "      <td>资深公关经理-金融PR出身</td>\n",
       "      <td>...</td>\n",
       "      <td>d3c3940f0df0813ea9314f85815c7193</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/7916546/</td>\n",
       "      <td>7916546</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>6305953c28e72769b4c22fb102u.png</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>胡润百富</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"recruiterName\":\"姚女士\",\"imId\":\"40c950d9be76abd...</td>\n",
       "      <td>[EMC设计, PCB设计, 软件开发, Altium Designer, Protel, ...</td>\n",
       "      <td>https://www.liepin.com/job/1959638707.shtml</td>\n",
       "      <td>59638707</td>\n",
       "      <td>深圳-宝安区</td>\n",
       "      <td>False</td>\n",
       "      <td>20231120092349</td>\n",
       "      <td>2</td>\n",
       "      <td>EMC工程师</td>\n",
       "      <td>...</td>\n",
       "      <td>c3ad4056ce65fc5d293e71c3e8702e15</td>\n",
       "      <td>5f8f9863f6d1ab58476f246a08u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/1649098/</td>\n",
       "      <td>1649098</td>\n",
       "      <td>2000-5000人</td>\n",
       "      <td>5bf922508e506f9e85931fdc04a.jpg</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>深圳市联建光电股份有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>沪深A股上市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"recruiterName\":\"许女士\",\"imId\":\"44eae85f6054c60...</td>\n",
       "      <td>[视觉设计, 平面设计, VI设计, 广告设计, 品牌设计, 创意设计, 物料设计, Pho...</td>\n",
       "      <td>https://www.liepin.com/job/1959631431.shtml</td>\n",
       "      <td>59631431</td>\n",
       "      <td>深圳-宝安区</td>\n",
       "      <td>False</td>\n",
       "      <td>20230628164714</td>\n",
       "      <td>2</td>\n",
       "      <td>平面设计师</td>\n",
       "      <td>...</td>\n",
       "      <td>b039f8f2e1f20aec37f4905b207ec932</td>\n",
       "      <td>5f8f98648dbe6273dcf8515508u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/13591649/</td>\n",
       "      <td>13591649</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>61b07937d0458d53c627567e02u.jpg</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>深圳符号逻辑设计有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"recruiterName\":\"邓女士\",\"imId\":\"bad7a9184de563d...</td>\n",
       "      <td>[品牌公关, 商务公关, 媒介公关, 活动公关, 会议论坛, 发布会, to B, to G...</td>\n",
       "      <td>https://www.liepin.com/job/1959631017.shtml</td>\n",
       "      <td>59631017</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>False</td>\n",
       "      <td>20231201172619</td>\n",
       "      <td>2</td>\n",
       "      <td>资深公关经理-金融PR出身</td>\n",
       "      <td>...</td>\n",
       "      <td>fab8aadcaab02460a3029238bee39c12</td>\n",
       "      <td>6360ec960ce01330f847c0e107u.jpeg</td>\n",
       "      <td>https://www.liepin.com/company/7916546/</td>\n",
       "      <td>7916546</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>6305953c28e72769b4c22fb102u.png</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>胡润百富</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"recruiterName\":\"王先生\",\"imId\":\"d5bc294b15565c9...</td>\n",
       "      <td>[品牌总监, 品牌顾问, 创意总监, 品牌老师, 定位咨询, 定位老师]</td>\n",
       "      <td>https://www.liepin.com/job/1959613675.shtml</td>\n",
       "      <td>59613675</td>\n",
       "      <td>深圳-龙岗区</td>\n",
       "      <td>False</td>\n",
       "      <td>20230717114859</td>\n",
       "      <td>2</td>\n",
       "      <td>品牌咨询顾问</td>\n",
       "      <td>...</td>\n",
       "      <td>3cd7c69bc663cab4af91f4d20e2eaaa8</td>\n",
       "      <td>5f8f986c79c7cc70efbf36c808u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/12433985/</td>\n",
       "      <td>12433985</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>5f89047aea60860b7535580107u.jpg</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>非常差异品牌营销策划(深圳)有限公司</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>400 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             dataInfo  \\\n",
       "0   %7B%22jobId%22%3A%2263221469%22%2C%22pageSize%...   \n",
       "1   %7B%22jobId%22%3A%2263078431%22%2C%22pageSize%...   \n",
       "2   %7B%22jobId%22%3A%2262439369%22%2C%22pageSize%...   \n",
       "3   %7B%22jobId%22%3A%2262386299%22%2C%22pageSize%...   \n",
       "4   %7B%22jobId%22%3A%2261949069%22%2C%22pageSize%...   \n",
       "..                                                ...   \n",
       "35  %7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...   \n",
       "36  %7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...   \n",
       "37  %7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...   \n",
       "38  %7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...   \n",
       "39  %7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...   \n",
       "\n",
       "                                           dataParams  \\\n",
       "0   {\"jobId\":\"63221469\",\"imId\":\"f3a453fd191548accb...   \n",
       "1   {\"jobId\":\"63078431\",\"imId\":\"ff0eab8eea20c36621...   \n",
       "2   {\"jobId\":\"62439369\",\"imId\":\"cad5be4e96049ddf80...   \n",
       "3   {\"jobId\":\"62386299\",\"imId\":\"17cca1ce48d9b11714...   \n",
       "4   {\"jobId\":\"61949069\",\"imId\":\"b099ed3311071e4673...   \n",
       "..                                                ...   \n",
       "35  {\"recruiterName\":\"梁女士\",\"imId\":\"43372946af5e7c5...   \n",
       "36  {\"recruiterName\":\"姚女士\",\"imId\":\"40c950d9be76abd...   \n",
       "37  {\"recruiterName\":\"许女士\",\"imId\":\"44eae85f6054c60...   \n",
       "38  {\"recruiterName\":\"邓女士\",\"imId\":\"bad7a9184de563d...   \n",
       "39  {\"recruiterName\":\"王先生\",\"imId\":\"d5bc294b15565c9...   \n",
       "\n",
       "                                           job.labels  \\\n",
       "0   [公关策划, 品牌推广, 市场推广, 市场营销, 市场策划, 市场调研分析, 品牌活动, 电...   \n",
       "1                              [本科, 市场策划, 活动策划, 教育培训]   \n",
       "2                                           [6个月, 本科]   \n",
       "3                                      [本科, 销售方向, 销售]   \n",
       "4                                   [3个月, 本科, 人力资源经验]   \n",
       "..                                                ...   \n",
       "35  [品牌公关, 商务公关, 媒介公关, 活动公关, 会议论坛, 发布会, to B, to G...   \n",
       "36  [EMC设计, PCB设计, 软件开发, Altium Designer, Protel, ...   \n",
       "37  [视觉设计, 平面设计, VI设计, 广告设计, 品牌设计, 创意设计, 物料设计, Pho...   \n",
       "38  [品牌公关, 商务公关, 媒介公关, 活动公关, 会议论坛, 发布会, to B, to G...   \n",
       "39               [品牌总监, 品牌顾问, 创意总监, 品牌老师, 定位咨询, 定位老师]   \n",
       "\n",
       "                                       job.link job.jobId  job.dq  job.topJob  \\\n",
       "0   https://www.liepin.com/job/1963221469.shtml  63221469  深圳-南山区        True   \n",
       "1        https://www.liepin.com/lptjob/63078431  63078431  深圳-福田区       False   \n",
       "2        https://www.liepin.com/lptjob/62439369  62439369  深圳-南山区       False   \n",
       "3        https://www.liepin.com/lptjob/62386299  62386299  深圳-福田区       False   \n",
       "4        https://www.liepin.com/lptjob/61949069  61949069  深圳-南山区       False   \n",
       "..                                          ...       ...     ...         ...   \n",
       "35  https://www.liepin.com/job/1959644973.shtml  59644973  深圳-福田区       False   \n",
       "36  https://www.liepin.com/job/1959638707.shtml  59638707  深圳-宝安区       False   \n",
       "37  https://www.liepin.com/job/1959631431.shtml  59631431  深圳-宝安区       False   \n",
       "38  https://www.liepin.com/job/1959631017.shtml  59631017  深圳-福田区       False   \n",
       "39  https://www.liepin.com/job/1959613675.shtml  59613675  深圳-龙岗区       False   \n",
       "\n",
       "   job.refreshTime job.jobKind               job.title  ...  \\\n",
       "0   20231127190756           2                    市场经理  ...   \n",
       "1   20231127145532           6                  国际合作专员  ...   \n",
       "2   20231027110528           6  合同管理 intern (MJ000210)  ...   \n",
       "3   20231109094658           6                   营销培训生  ...   \n",
       "4   20231201175815           6                 行政人事实习生  ...   \n",
       "..             ...         ...                     ...  ...   \n",
       "35  20231129145821           2           资深公关经理-金融PR出身  ...   \n",
       "36  20231120092349           2                  EMC工程师  ...   \n",
       "37  20230628164714           2                   平面设计师  ...   \n",
       "38  20231201172619           2           资深公关经理-金融PR出身  ...   \n",
       "39  20230717114859           2                  品牌咨询顾问  ...   \n",
       "\n",
       "               recruiter.recruiterId          recruiter.recruiterPhoto  \\\n",
       "0   6e60308e0d7e0a5d35b7122fd419b76f   5f8f986779c7cc70efbf36c008u.jpg   \n",
       "1   31ae35dd25c393cef0498bd9e03ba548   5f8f986779c7cc70efbf36c008u.jpg   \n",
       "2   062818603e680b2da5f99130e9ef8d12   5f8f9866dfb13a7dee342f1808u.jpg   \n",
       "3   e7d4c09bd9ad172d971ee8f2edea25b2   63031de9636e1b234ac6a45505u.png   \n",
       "4   178348d10d4504ecab26c2c2437115e0   583f8dfa70324d1f7da02d2606a.png   \n",
       "..                               ...                               ...   \n",
       "35  d3c3940f0df0813ea9314f85815c7193   5f8f9865ea60860b75384fa508u.jpg   \n",
       "36  c3ad4056ce65fc5d293e71c3e8702e15   5f8f9863f6d1ab58476f246a08u.jpg   \n",
       "37  b039f8f2e1f20aec37f4905b207ec932   5f8f98648dbe6273dcf8515508u.jpg   \n",
       "38  fab8aadcaab02460a3029238bee39c12  6360ec960ce01330f847c0e107u.jpeg   \n",
       "39  3cd7c69bc663cab4af91f4d20e2eaaa8   5f8f986c79c7cc70efbf36c808u.jpg   \n",
       "\n",
       "                                   comp.link comp.compId comp.compScale  \\\n",
       "0   https://www.liepin.com/company/13165103/    13165103       100-499人   \n",
       "1   https://www.liepin.com/company/13332619/    13332619         50-99人   \n",
       "2    https://www.liepin.com/company/9638001/     9638001       100-499人   \n",
       "3    https://www.liepin.com/company/9272548/     9272548    5000-10000人   \n",
       "4    https://www.liepin.com/company/8904732/     8904732       500-999人   \n",
       "..                                       ...         ...            ...   \n",
       "35   https://www.liepin.com/company/7916546/     7916546       100-499人   \n",
       "36   https://www.liepin.com/company/1649098/     1649098     2000-5000人   \n",
       "37  https://www.liepin.com/company/13591649/    13591649          1-49人   \n",
       "38   https://www.liepin.com/company/7916546/     7916546       100-499人   \n",
       "39  https://www.liepin.com/company/12433985/    12433985          1-49人   \n",
       "\n",
       "                       comp.compLogo comp.compIndustry       comp.compName  \\\n",
       "0    6247ff3b3247ad31bb6a350808u.png          广告/公关/会展   贝克斯数字媒体技术(深圳)有限公司   \n",
       "1    65643db3aef7c833d61189e304u.png          广告/公关/会展              正壹会展集团   \n",
       "2   5ef7eac6639c8353865e8cfa03u.jpeg          广告/公关/会展        上海邑炎信息科技有限公司   \n",
       "3    636c9f9f19919c4d06ca723f04u.png          广告/公关/会展              新潮传媒集团   \n",
       "4    6045d2d247efeb69daf7dd0708u.png          广告/公关/会展                博雅公关   \n",
       "..                               ...               ...                 ...   \n",
       "35   6305953c28e72769b4c22fb102u.png          广告/公关/会展                胡润百富   \n",
       "36   5bf922508e506f9e85931fdc04a.jpg          广告/公关/会展       深圳市联建光电股份有限公司   \n",
       "37   61b07937d0458d53c627567e02u.jpg          广告/公关/会展        深圳符号逻辑设计有限公司   \n",
       "38   6305953c28e72769b4c22fb102u.png          广告/公关/会展                胡润百富   \n",
       "39   5f89047aea60860b7535580107u.jpg          广告/公关/会展  非常差异品牌营销策划(深圳)有限公司   \n",
       "\n",
       "   job.campusJobKind  comp.compStage  \n",
       "0                NaN             NaN  \n",
       "1                 应届              其他  \n",
       "2                 实习           融资未公开  \n",
       "3                 应届              D轮  \n",
       "4                 实习             NaN  \n",
       "..               ...             ...  \n",
       "35               NaN             NaN  \n",
       "36               NaN          沪深A股上市  \n",
       "37               NaN             NaN  \n",
       "38               NaN             NaN  \n",
       "39               NaN             NaN  \n",
       "\n",
       "[400 rows x 32 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import crawl_liepin\n",
    "\n",
    "crawl_liepin.crawl(城市=\"深圳\",关键词=\"\",学历= \"本科\",行业=\"广告\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "a90942a7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'inited_user=a3e2a6692c06d3ee2a77de7db5f87d9d; __uuid=1681902695314.85; __gc_id=5345367cb21c4298a544835e18c56d1f; need_bind_tel=false; c_flag=5b991c00b1dd3c936104eb0f28aad784; _ga=GA1.1.1004117102.1681904443; new_user=false; imId=bdd7042bddfede3f6846d40b980161c2; imId_0=bdd7042bddfede3f6846d40b980161c2; imClientId=bdd7042bddfede3f8c4e11c17165661e; imClientId_0=bdd7042bddfede3f8c4e11c17165661e; XSRF-TOKEN=ZNW_26Q9SzGF9lYv6QRPBA; __tlog=1701256347630.50%7C00000000%7C00000000%7Cs_o_007%7Cs_o_007; Hm_lvt_a2647413544f5a04f00da7eee0d5e200=1698838424,1700049509,1701256348; UniqueKey=267e69689bc2f92b6bc56763ae71c6f2; liepin_login_valid=0; lt_auth=v%2B9caXUBmlqr4Xjd3GJYsf0f24ihWGya%2FXgK0UgAhd68DvPi4P%2FmQAmPr7EE%2BCoIq0gnI6kzMLf%2BNOr7z3BC7EYV%2FVGnlZ6utf6k1XweTuxlHuyflMXuqsjQQ5wtrXo6ykpgn2si0HU%3D; access_system=C; user_roles=0; user_photo=5f8fa3baf6d1ab58476f324908u.png; user_name=%E8%B5%96%E6%96%87%E4%BD%A9; inited_user=a3e2a6692c06d3ee2a77de7db5f87d9d; hpo_role-sec_project=sec_project_liepin; hpo_sec_tenant=0; imApp_0=1; acw_tc=276077ba17012604467485820e70d4da2c9fb1aa8355e3c77ae9c748ee57af; Hm_lpvt_a2647413544f5a04f00da7eee0d5e200=1701260826; fe_im_socketSequence_new_0=7_6_6; __session_seq=20; __uv_seq=20; __tlg_event_seq=286; fe_im_opened_pages=; fe_im_connectJson_0=%7B%220_267e69689bc2f92b6bc56763ae71c6f2%22%3A%7B%22socketConnect%22%3A%222%22%2C%22connectDomain%22%3A%22liepin.com%22%7D%7D; _ga_54YTJKWN86=GS1.1.1701260819.21.1.1701261828.0.0.0'"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cookie = \"inited_user=a3e2a6692c06d3ee2a77de7db5f87d9d; __uuid=1681902695314.85; __gc_id=5345367cb21c4298a544835e18c56d1f; need_bind_tel=false; c_flag=5b991c00b1dd3c936104eb0f28aad784; _ga=GA1.1.1004117102.1681904443; new_user=false; imId=bdd7042bddfede3f6846d40b980161c2; imId_0=bdd7042bddfede3f6846d40b980161c2; imClientId=bdd7042bddfede3f8c4e11c17165661e; imClientId_0=bdd7042bddfede3f8c4e11c17165661e; XSRF-TOKEN=ZNW_26Q9SzGF9lYv6QRPBA; __tlog=1701256347630.50%7C00000000%7C00000000%7Cs_o_007%7Cs_o_007; Hm_lvt_a2647413544f5a04f00da7eee0d5e200=1698838424,1700049509,1701256348; UniqueKey=267e69689bc2f92b6bc56763ae71c6f2; liepin_login_valid=0; lt_auth=v%2B9caXUBmlqr4Xjd3GJYsf0f24ihWGya%2FXgK0UgAhd68DvPi4P%2FmQAmPr7EE%2BCoIq0gnI6kzMLf%2BNOr7z3BC7EYV%2FVGnlZ6utf6k1XweTuxlHuyflMXuqsjQQ5wtrXo6ykpgn2si0HU%3D; access_system=C; user_roles=0; user_photo=5f8fa3baf6d1ab58476f324908u.png; user_name=%E8%B5%96%E6%96%87%E4%BD%A9; inited_user=a3e2a6692c06d3ee2a77de7db5f87d9d; hpo_role-sec_project=sec_project_liepin; hpo_sec_tenant=0; imApp_0=1; acw_tc=276077ba17012604467485820e70d4da2c9fb1aa8355e3c77ae9c748ee57af; Hm_lpvt_a2647413544f5a04f00da7eee0d5e200=1701260826; fe_im_socketSequence_new_0=7_6_6; __session_seq=20; __uv_seq=20; __tlg_event_seq=286; fe_im_opened_pages=; fe_im_connectJson_0=%7B%220_267e69689bc2f92b6bc56763ae71c6f2%22%3A%7B%22socketConnect%22%3A%222%22%2C%22connectDomain%22%3A%22liepin.com%22%7D%7D; _ga_54YTJKWN86=GS1.1.1701260819.21.1.1701261828.0.0.0\"\n",
    "cookie"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "53a5c82d",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "登录cookie inited_user=a3e2a6692c06d3ee2a77de7db5f87d9d; __uuid=1681902695314.85; __gc_id=5345367cb21c4298a544835e18c56d1f; need_bind_tel=false; c_flag=5b991c00b1dd3c936104eb0f28aad784; _ga=GA1.1.1004117102.1681904443; new_user=false; imId=bdd7042bddfede3f6846d40b980161c2; imId_0=bdd7042bddfede3f6846d40b980161c2; imClientId=bdd7042bddfede3f8c4e11c17165661e; imClientId_0=bdd7042bddfede3f8c4e11c17165661e; XSRF-TOKEN=ZNW_26Q9SzGF9lYv6QRPBA; __tlog=1701256347630.50%7C00000000%7C00000000%7Cs_o_007%7Cs_o_007; Hm_lvt_a2647413544f5a04f00da7eee0d5e200=1698838424,1700049509,1701256348; UniqueKey=267e69689bc2f92b6bc56763ae71c6f2; liepin_login_valid=0; lt_auth=v%2B9caXUBmlqr4Xjd3GJYsf0f24ihWGya%2FXgK0UgAhd68DvPi4P%2FmQAmPr7EE%2BCoIq0gnI6kzMLf%2BNOr7z3BC7EYV%2FVGnlZ6utf6k1XweTuxlHuyflMXuqsjQQ5wtrXo6ykpgn2si0HU%3D; access_system=C; user_roles=0; user_photo=5f8fa3baf6d1ab58476f324908u.png; user_name=%E8%B5%96%E6%96%87%E4%BD%A9; inited_user=a3e2a6692c06d3ee2a77de7db5f87d9d; hpo_role-sec_project=sec_project_liepin; hpo_sec_tenant=0; imApp_0=1; acw_tc=276077ba17012604467485820e70d4da2c9fb1aa8355e3c77ae9c748ee57af; Hm_lpvt_a2647413544f5a04f00da7eee0d5e200=1701260826; fe_im_socketSequence_new_0=7_6_6; __session_seq=20; __uv_seq=20; __tlg_event_seq=286; fe_im_opened_pages=; fe_im_connectJson_0=%7B%220_267e69689bc2f92b6bc56763ae71c6f2%22%3A%7B%22socketConnect%22%3A%222%22%2C%22connectDomain%22%3A%22liepin.com%22%7D%7D; _ga_54YTJKWN86=GS1.1.1701260819.21.1.1701261828.0.0.0\n",
      "这是第1页，接下来将先等待5秒...然后以继续抓取\n",
      "这是第2页，接下来将先等待4秒...然后以继续抓取\n",
      "这是第3页，接下来将先等待3秒...然后以继续抓取\n",
      "这是第4页，接下来将先等待6秒...然后以继续抓取\n",
      "这是第5页，接下来将先等待4秒...然后以继续抓取\n",
      "这是第6页，接下来将先等待6秒...然后以继续抓取\n",
      "这是第7页，接下来将先等待9秒...然后以继续抓取\n",
      "这是第8页，接下来将先等待3秒...然后以继续抓取\n",
      "这是第9页，接下来将先等待6秒...然后以继续抓取\n",
      "这是第10页，接下来将先等待10秒...然后以继续抓取\n"
     ]
    }
   ],
   "source": [
    "import crawl_liepin\n",
    "\n",
    "广告行业_深圳_results = crawl_liepin.crawl(城市=\"深圳\",关键词=\"\",学历='本科',行业='广告',登录cookie=cookie)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "0a050083",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "4cdb1bb7",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>dataInfo</th>\n",
       "      <th>dataParams</th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.link</th>\n",
       "      <th>job.title</th>\n",
       "      <th>job.dq</th>\n",
       "      <th>job.refreshTime</th>\n",
       "      <th>job.jobKind</th>\n",
       "      <th>job.topJob</th>\n",
       "      <th>job.jobId</th>\n",
       "      <th>...</th>\n",
       "      <th>recruiter.recruiterId</th>\n",
       "      <th>recruiter.recruiterPhoto</th>\n",
       "      <th>comp.link</th>\n",
       "      <th>comp.compLogo</th>\n",
       "      <th>comp.compScale</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>comp.compId</th>\n",
       "      <th>job.campusJobKind</th>\n",
       "      <th>comp.compStage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>%7B%22skId%22%3A%22geq5b0qsi9umzbhn0oojbi2j8v8...</td>\n",
       "      <td>{\"userId\":\"6e60308e0d7e0a5d35b7122fd419b76f\",\"...</td>\n",
       "      <td>[公关策划, 品牌推广, 市场推广, 市场营销, 市场策划, 市场调研分析, 品牌活动, 电...</td>\n",
       "      <td>https://www.liepin.com/job/1963221469.shtml</td>\n",
       "      <td>市场经理</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>20231127190756</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>63221469</td>\n",
       "      <td>...</td>\n",
       "      <td>6e60308e0d7e0a5d35b7122fd419b76f</td>\n",
       "      <td>5f8f986779c7cc70efbf36c008u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/13165103/</td>\n",
       "      <td>6247ff3b3247ad31bb6a350808u.png</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>贝克斯数字媒体技术(深圳)有限公司</td>\n",
       "      <td>13165103</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>%7B%22skId%22%3A%22geq5b0qsi9umzbhn0oojbi2j8v8...</td>\n",
       "      <td>{\"userId\":\"31ae35dd25c393cef0498bd9e03ba548\",\"...</td>\n",
       "      <td>[本科, 市场策划, 活动策划, 教育培训]</td>\n",
       "      <td>https://www.liepin.com/lptjob/63078431</td>\n",
       "      <td>国际合作专员</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>20231127145532</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>63078431</td>\n",
       "      <td>...</td>\n",
       "      <td>31ae35dd25c393cef0498bd9e03ba548</td>\n",
       "      <td>5f8f986779c7cc70efbf36c008u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/13332619/</td>\n",
       "      <td>65643db3aef7c833d61189e304u.png</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>正壹会展集团</td>\n",
       "      <td>13332619</td>\n",
       "      <td>应届</td>\n",
       "      <td>其他</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>%7B%22skId%22%3A%22geq5b0qsi9umzbhn0oojbi2j8v8...</td>\n",
       "      <td>{\"userId\":\"062818603e680b2da5f99130e9ef8d12\",\"...</td>\n",
       "      <td>[6个月, 本科]</td>\n",
       "      <td>https://www.liepin.com/lptjob/62439369</td>\n",
       "      <td>合同管理 intern (MJ000210)</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>20231027110528</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>62439369</td>\n",
       "      <td>...</td>\n",
       "      <td>062818603e680b2da5f99130e9ef8d12</td>\n",
       "      <td>5f8f9866dfb13a7dee342f1808u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/9638001/</td>\n",
       "      <td>5ef7eac6639c8353865e8cfa03u.jpeg</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>上海邑炎信息科技有限公司</td>\n",
       "      <td>9638001</td>\n",
       "      <td>实习</td>\n",
       "      <td>融资未公开</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>%7B%22skId%22%3A%22geq5b0qsi9umzbhn0oojbi2j8v8...</td>\n",
       "      <td>{\"userId\":\"e7d4c09bd9ad172d971ee8f2edea25b2\",\"...</td>\n",
       "      <td>[本科, 销售方向, 销售]</td>\n",
       "      <td>https://www.liepin.com/lptjob/62386299</td>\n",
       "      <td>营销培训生</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>20231109094658</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>62386299</td>\n",
       "      <td>...</td>\n",
       "      <td>e7d4c09bd9ad172d971ee8f2edea25b2</td>\n",
       "      <td>63031de9636e1b234ac6a45505u.png</td>\n",
       "      <td>https://www.liepin.com/company/9272548/</td>\n",
       "      <td>636c9f9f19919c4d06ca723f04u.png</td>\n",
       "      <td>5000-10000人</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>新潮传媒集团</td>\n",
       "      <td>9272548</td>\n",
       "      <td>应届</td>\n",
       "      <td>D轮</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>%7B%22skId%22%3A%22geq5b0qsi9umzbhn0oojbi2j8v8...</td>\n",
       "      <td>{\"userId\":\"178348d10d4504ecab26c2c2437115e0\",\"...</td>\n",
       "      <td>[3个月, 本科, 人力资源经验]</td>\n",
       "      <td>https://www.liepin.com/lptjob/61949069</td>\n",
       "      <td>行政人事实习生</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>20231201175815</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>61949069</td>\n",
       "      <td>...</td>\n",
       "      <td>178348d10d4504ecab26c2c2437115e0</td>\n",
       "      <td>583f8dfa70324d1f7da02d2606a.png</td>\n",
       "      <td>https://www.liepin.com/company/8904732/</td>\n",
       "      <td>6045d2d247efeb69daf7dd0708u.png</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>博雅公关</td>\n",
       "      <td>8904732</td>\n",
       "      <td>实习</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>%7B%22jobId%22%3A%2259644973%22%2C%22jobKind%2...</td>\n",
       "      <td>{\"jobId\":\"59644973\",\"jobKind\":\"2\",\"imId\":\"4337...</td>\n",
       "      <td>[品牌公关, 商务公关, 媒介公关, 活动公关, 会议论坛, 发布会, to B, to G...</td>\n",
       "      <td>https://www.liepin.com/job/1959644973.shtml</td>\n",
       "      <td>资深公关经理-金融PR出身</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>20231129145821</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>59644973</td>\n",
       "      <td>...</td>\n",
       "      <td>d3c3940f0df0813ea9314f85815c7193</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/7916546/</td>\n",
       "      <td>6305953c28e72769b4c22fb102u.png</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>胡润百富</td>\n",
       "      <td>7916546</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>%7B%22jobId%22%3A%2259638707%22%2C%22jobKind%2...</td>\n",
       "      <td>{\"jobId\":\"59638707\",\"jobKind\":\"2\",\"imId\":\"40c9...</td>\n",
       "      <td>[EMC设计, PCB设计, 软件开发, Altium Designer, Protel, ...</td>\n",
       "      <td>https://www.liepin.com/job/1959638707.shtml</td>\n",
       "      <td>EMC工程师</td>\n",
       "      <td>深圳-宝安区</td>\n",
       "      <td>20231120092349</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>59638707</td>\n",
       "      <td>...</td>\n",
       "      <td>c3ad4056ce65fc5d293e71c3e8702e15</td>\n",
       "      <td>5f8f9863f6d1ab58476f246a08u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/1649098/</td>\n",
       "      <td>5bf922508e506f9e85931fdc04a.jpg</td>\n",
       "      <td>2000-5000人</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>深圳市联建光电股份有限公司</td>\n",
       "      <td>1649098</td>\n",
       "      <td>NaN</td>\n",
       "      <td>沪深A股上市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>%7B%22jobId%22%3A%2259631431%22%2C%22jobKind%2...</td>\n",
       "      <td>{\"jobId\":\"59631431\",\"jobKind\":\"2\",\"imId\":\"44ea...</td>\n",
       "      <td>[视觉设计, 平面设计, VI设计, 广告设计, 品牌设计, 创意设计, 物料设计, Pho...</td>\n",
       "      <td>https://www.liepin.com/job/1959631431.shtml</td>\n",
       "      <td>平面设计师</td>\n",
       "      <td>深圳-宝安区</td>\n",
       "      <td>20230628164714</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>59631431</td>\n",
       "      <td>...</td>\n",
       "      <td>b039f8f2e1f20aec37f4905b207ec932</td>\n",
       "      <td>5f8f98648dbe6273dcf8515508u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/13591649/</td>\n",
       "      <td>61b07937d0458d53c627567e02u.jpg</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>深圳符号逻辑设计有限公司</td>\n",
       "      <td>13591649</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>%7B%22jobId%22%3A%2259631017%22%2C%22jobKind%2...</td>\n",
       "      <td>{\"jobId\":\"59631017\",\"jobKind\":\"2\",\"imId\":\"bad7...</td>\n",
       "      <td>[品牌公关, 商务公关, 媒介公关, 活动公关, 会议论坛, 发布会, to B, to G...</td>\n",
       "      <td>https://www.liepin.com/job/1959631017.shtml</td>\n",
       "      <td>资深公关经理-金融PR出身</td>\n",
       "      <td>深圳-福田区</td>\n",
       "      <td>20231201172619</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>59631017</td>\n",
       "      <td>...</td>\n",
       "      <td>fab8aadcaab02460a3029238bee39c12</td>\n",
       "      <td>6360ec960ce01330f847c0e107u.jpeg</td>\n",
       "      <td>https://www.liepin.com/company/7916546/</td>\n",
       "      <td>6305953c28e72769b4c22fb102u.png</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>胡润百富</td>\n",
       "      <td>7916546</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>%7B%22jobId%22%3A%2259613675%22%2C%22jobKind%2...</td>\n",
       "      <td>{\"jobId\":\"59613675\",\"jobKind\":\"2\",\"imId\":\"d5bc...</td>\n",
       "      <td>[品牌总监, 品牌顾问, 创意总监, 品牌老师, 定位咨询, 定位老师]</td>\n",
       "      <td>https://www.liepin.com/job/1959613675.shtml</td>\n",
       "      <td>品牌咨询顾问</td>\n",
       "      <td>深圳-龙岗区</td>\n",
       "      <td>20230717114859</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>59613675</td>\n",
       "      <td>...</td>\n",
       "      <td>3cd7c69bc663cab4af91f4d20e2eaaa8</td>\n",
       "      <td>5f8f986c79c7cc70efbf36c808u.jpg</td>\n",
       "      <td>https://www.liepin.com/company/12433985/</td>\n",
       "      <td>5f89047aea60860b7535580107u.jpg</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>广告/公关/会展</td>\n",
       "      <td>非常差异品牌营销策划(深圳)有限公司</td>\n",
       "      <td>12433985</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>400 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             dataInfo  \\\n",
       "0   %7B%22skId%22%3A%22geq5b0qsi9umzbhn0oojbi2j8v8...   \n",
       "1   %7B%22skId%22%3A%22geq5b0qsi9umzbhn0oojbi2j8v8...   \n",
       "2   %7B%22skId%22%3A%22geq5b0qsi9umzbhn0oojbi2j8v8...   \n",
       "3   %7B%22skId%22%3A%22geq5b0qsi9umzbhn0oojbi2j8v8...   \n",
       "4   %7B%22skId%22%3A%22geq5b0qsi9umzbhn0oojbi2j8v8...   \n",
       "..                                                ...   \n",
       "35  %7B%22jobId%22%3A%2259644973%22%2C%22jobKind%2...   \n",
       "36  %7B%22jobId%22%3A%2259638707%22%2C%22jobKind%2...   \n",
       "37  %7B%22jobId%22%3A%2259631431%22%2C%22jobKind%2...   \n",
       "38  %7B%22jobId%22%3A%2259631017%22%2C%22jobKind%2...   \n",
       "39  %7B%22jobId%22%3A%2259613675%22%2C%22jobKind%2...   \n",
       "\n",
       "                                           dataParams  \\\n",
       "0   {\"userId\":\"6e60308e0d7e0a5d35b7122fd419b76f\",\"...   \n",
       "1   {\"userId\":\"31ae35dd25c393cef0498bd9e03ba548\",\"...   \n",
       "2   {\"userId\":\"062818603e680b2da5f99130e9ef8d12\",\"...   \n",
       "3   {\"userId\":\"e7d4c09bd9ad172d971ee8f2edea25b2\",\"...   \n",
       "4   {\"userId\":\"178348d10d4504ecab26c2c2437115e0\",\"...   \n",
       "..                                                ...   \n",
       "35  {\"jobId\":\"59644973\",\"jobKind\":\"2\",\"imId\":\"4337...   \n",
       "36  {\"jobId\":\"59638707\",\"jobKind\":\"2\",\"imId\":\"40c9...   \n",
       "37  {\"jobId\":\"59631431\",\"jobKind\":\"2\",\"imId\":\"44ea...   \n",
       "38  {\"jobId\":\"59631017\",\"jobKind\":\"2\",\"imId\":\"bad7...   \n",
       "39  {\"jobId\":\"59613675\",\"jobKind\":\"2\",\"imId\":\"d5bc...   \n",
       "\n",
       "                                           job.labels  \\\n",
       "0   [公关策划, 品牌推广, 市场推广, 市场营销, 市场策划, 市场调研分析, 品牌活动, 电...   \n",
       "1                              [本科, 市场策划, 活动策划, 教育培训]   \n",
       "2                                           [6个月, 本科]   \n",
       "3                                      [本科, 销售方向, 销售]   \n",
       "4                                   [3个月, 本科, 人力资源经验]   \n",
       "..                                                ...   \n",
       "35  [品牌公关, 商务公关, 媒介公关, 活动公关, 会议论坛, 发布会, to B, to G...   \n",
       "36  [EMC设计, PCB设计, 软件开发, Altium Designer, Protel, ...   \n",
       "37  [视觉设计, 平面设计, VI设计, 广告设计, 品牌设计, 创意设计, 物料设计, Pho...   \n",
       "38  [品牌公关, 商务公关, 媒介公关, 活动公关, 会议论坛, 发布会, to B, to G...   \n",
       "39               [品牌总监, 品牌顾问, 创意总监, 品牌老师, 定位咨询, 定位老师]   \n",
       "\n",
       "                                       job.link               job.title  \\\n",
       "0   https://www.liepin.com/job/1963221469.shtml                    市场经理   \n",
       "1        https://www.liepin.com/lptjob/63078431                  国际合作专员   \n",
       "2        https://www.liepin.com/lptjob/62439369  合同管理 intern (MJ000210)   \n",
       "3        https://www.liepin.com/lptjob/62386299                   营销培训生   \n",
       "4        https://www.liepin.com/lptjob/61949069                 行政人事实习生   \n",
       "..                                          ...                     ...   \n",
       "35  https://www.liepin.com/job/1959644973.shtml           资深公关经理-金融PR出身   \n",
       "36  https://www.liepin.com/job/1959638707.shtml                  EMC工程师   \n",
       "37  https://www.liepin.com/job/1959631431.shtml                   平面设计师   \n",
       "38  https://www.liepin.com/job/1959631017.shtml           资深公关经理-金融PR出身   \n",
       "39  https://www.liepin.com/job/1959613675.shtml                  品牌咨询顾问   \n",
       "\n",
       "    job.dq job.refreshTime job.jobKind  job.topJob job.jobId  ...  \\\n",
       "0   深圳-南山区  20231127190756           2        True  63221469  ...   \n",
       "1   深圳-福田区  20231127145532           6       False  63078431  ...   \n",
       "2   深圳-南山区  20231027110528           6       False  62439369  ...   \n",
       "3   深圳-福田区  20231109094658           6       False  62386299  ...   \n",
       "4   深圳-南山区  20231201175815           6       False  61949069  ...   \n",
       "..     ...             ...         ...         ...       ...  ...   \n",
       "35  深圳-福田区  20231129145821           2       False  59644973  ...   \n",
       "36  深圳-宝安区  20231120092349           2       False  59638707  ...   \n",
       "37  深圳-宝安区  20230628164714           2       False  59631431  ...   \n",
       "38  深圳-福田区  20231201172619           2       False  59631017  ...   \n",
       "39  深圳-龙岗区  20230717114859           2       False  59613675  ...   \n",
       "\n",
       "               recruiter.recruiterId          recruiter.recruiterPhoto  \\\n",
       "0   6e60308e0d7e0a5d35b7122fd419b76f   5f8f986779c7cc70efbf36c008u.jpg   \n",
       "1   31ae35dd25c393cef0498bd9e03ba548   5f8f986779c7cc70efbf36c008u.jpg   \n",
       "2   062818603e680b2da5f99130e9ef8d12   5f8f9866dfb13a7dee342f1808u.jpg   \n",
       "3   e7d4c09bd9ad172d971ee8f2edea25b2   63031de9636e1b234ac6a45505u.png   \n",
       "4   178348d10d4504ecab26c2c2437115e0   583f8dfa70324d1f7da02d2606a.png   \n",
       "..                               ...                               ...   \n",
       "35  d3c3940f0df0813ea9314f85815c7193   5f8f9865ea60860b75384fa508u.jpg   \n",
       "36  c3ad4056ce65fc5d293e71c3e8702e15   5f8f9863f6d1ab58476f246a08u.jpg   \n",
       "37  b039f8f2e1f20aec37f4905b207ec932   5f8f98648dbe6273dcf8515508u.jpg   \n",
       "38  fab8aadcaab02460a3029238bee39c12  6360ec960ce01330f847c0e107u.jpeg   \n",
       "39  3cd7c69bc663cab4af91f4d20e2eaaa8   5f8f986c79c7cc70efbf36c808u.jpg   \n",
       "\n",
       "                                   comp.link  \\\n",
       "0   https://www.liepin.com/company/13165103/   \n",
       "1   https://www.liepin.com/company/13332619/   \n",
       "2    https://www.liepin.com/company/9638001/   \n",
       "3    https://www.liepin.com/company/9272548/   \n",
       "4    https://www.liepin.com/company/8904732/   \n",
       "..                                       ...   \n",
       "35   https://www.liepin.com/company/7916546/   \n",
       "36   https://www.liepin.com/company/1649098/   \n",
       "37  https://www.liepin.com/company/13591649/   \n",
       "38   https://www.liepin.com/company/7916546/   \n",
       "39  https://www.liepin.com/company/12433985/   \n",
       "\n",
       "                       comp.compLogo  comp.compScale comp.compIndustry  \\\n",
       "0    6247ff3b3247ad31bb6a350808u.png        100-499人          广告/公关/会展   \n",
       "1    65643db3aef7c833d61189e304u.png          50-99人          广告/公关/会展   \n",
       "2   5ef7eac6639c8353865e8cfa03u.jpeg        100-499人          广告/公关/会展   \n",
       "3    636c9f9f19919c4d06ca723f04u.png     5000-10000人          广告/公关/会展   \n",
       "4    6045d2d247efeb69daf7dd0708u.png        500-999人          广告/公关/会展   \n",
       "..                               ...             ...               ...   \n",
       "35   6305953c28e72769b4c22fb102u.png        100-499人          广告/公关/会展   \n",
       "36   5bf922508e506f9e85931fdc04a.jpg      2000-5000人          广告/公关/会展   \n",
       "37   61b07937d0458d53c627567e02u.jpg           1-49人          广告/公关/会展   \n",
       "38   6305953c28e72769b4c22fb102u.png        100-499人          广告/公关/会展   \n",
       "39   5f89047aea60860b7535580107u.jpg           1-49人          广告/公关/会展   \n",
       "\n",
       "         comp.compName comp.compId job.campusJobKind comp.compStage  \n",
       "0    贝克斯数字媒体技术(深圳)有限公司    13165103               NaN            NaN  \n",
       "1               正壹会展集团    13332619                应届             其他  \n",
       "2         上海邑炎信息科技有限公司     9638001                实习          融资未公开  \n",
       "3               新潮传媒集团     9272548                应届             D轮  \n",
       "4                 博雅公关     8904732                实习            NaN  \n",
       "..                 ...         ...               ...            ...  \n",
       "35                胡润百富     7916546               NaN            NaN  \n",
       "36       深圳市联建光电股份有限公司     1649098               NaN         沪深A股上市  \n",
       "37        深圳符号逻辑设计有限公司    13591649               NaN            NaN  \n",
       "38                胡润百富     7916546               NaN            NaN  \n",
       "39  非常差异品牌营销策划(深圳)有限公司    12433985               NaN            NaN  \n",
       "\n",
       "[400 rows x 32 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=pd.DataFrame(广告行业_深圳_results)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "ce2276db",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_excel('广告行业_深圳_results.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "cc34a218",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4ad38df8",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
